﻿<html lang="zh">
<head><title>RuYiAdmin数据库设计文档</title>
  <style type='text/css'>body {
    padding-bottom: 50px
  }

  body, td {
    font-family: verdana, fantasy;
    font-size: 12px;
    line-height: 150%
  }

  table {
    width: 100%;
    background-color: #ccc;
    margin: 5px 0
  }

  td {
    background-color: #fff;
    padding: 3px 3px 3px 10px
  }

  thead td {
    text-align: center;
    font-weight: bold;
    background-color: #eee
  }

  a:link, a:visited, a:active {
    color: #015fb6;
    text-decoration: none
  }

  a:hover {
    color: #e33e06
  }</style>
</head>
<body style='text-align:center;'>
<div style='width:800px; margin:20px auto; text-align:left;'><a name='index'></a>
  <h2 style='text-align:center; line-height:50px;'>RuYiAdmin数据库设计文档</h2>
  <div><b>数据库名：RuYiAdmin-SpringBoot</b><br><b>文档版本：0.0.1-SNAPSHOT</b><br><b>文档描述：RuYiAdmin数据库设计文档</b><br></div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>表名</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td><a href='#biz_account'>biz_account</a></td>
      <td>模块API访问账号表</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td><a href='#biz_module'>biz_module</a></td>
      <td>模块表</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td><a href='#biz_user'>biz_user</a></td>
      <td>模块用户表</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td><a href='#biz_user_module'>biz_user_module</a></td>
      <td>模块与用户关系表</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td><a href='#sys_addressee'>sys_addressee</a></td>
      <td>收件人表</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td><a href='#sys_announcement'>sys_announcement</a></td>
      <td>通知公告表</td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td><a href='#sys_area'>sys_area</a></td>
      <td>行政区域表</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td><a href='#sys_attachment'>sys_attachment</a></td>
      <td>系统附件表</td>
    </tr>
    <tr>
      <td style='text-align:center;'>9</td>
      <td><a href='#sys_code_table'>sys_code_table</a></td>
      <td>字典表</td>
    </tr>
    <tr>
      <td style='text-align:center;'>10</td>
      <td><a href='#sys_import_config'>sys_import_config</a></td>
      <td>导入配置主表</td>
    </tr>
    <tr>
      <td style='text-align:center;'>11</td>
      <td><a href='#sys_import_config_detail'>sys_import_config_detail</a></td>
      <td>导入配置子表</td>
    </tr>
    <tr>
      <td style='text-align:center;'>12</td>
      <td><a href='#sys_language'>sys_language</a></td>
      <td>系统语言</td>
    </tr>
    <tr>
      <td style='text-align:center;'>13</td>
      <td><a href='#sys_log'>sys_log</a></td>
      <td>审计日志表</td>
    </tr>
    <tr>
      <td style='text-align:center;'>14</td>
      <td><a href='#sys_menu'>sys_menu</a></td>
      <td>菜单表</td>
    </tr>
    <tr>
      <td style='text-align:center;'>15</td>
      <td><a href='#sys_menu_language'>sys_menu_language</a></td>
      <td>菜单多语表</td>
    </tr>
    <tr>
      <td style='text-align:center;'>16</td>
      <td><a href='#sys_org_user'>sys_org_user</a></td>
      <td>机构用户关系表</td>
    </tr>
    <tr>
      <td style='text-align:center;'>17</td>
      <td><a href='#sys_organization'>sys_organization</a></td>
      <td>机构表</td>
    </tr>
    <tr>
      <td style='text-align:center;'>18</td>
      <td><a href='#sys_record'>sys_record</a></td>
      <td>系统记录表</td>
    </tr>
    <tr>
      <td style='text-align:center;'>19</td>
      <td><a href='#sys_role'>sys_role</a></td>
      <td>角色表</td>
    </tr>
    <tr>
      <td style='text-align:center;'>20</td>
      <td><a href='#sys_role_menu'>sys_role_menu</a></td>
      <td>角色菜单关系表</td>
    </tr>
    <tr>
      <td style='text-align:center;'>21</td>
      <td><a href='#sys_role_org'>sys_role_org</a></td>
      <td>角色机构关系表</td>
    </tr>
    <tr>
      <td style='text-align:center;'>22</td>
      <td><a href='#sys_role_user'>sys_role_user</a></td>
      <td>角色用户关系表</td>
    </tr>
    <tr>
      <td style='text-align:center;'>23</td>
      <td><a href='#sys_schedule_job'>sys_schedule_job</a></td>
      <td>计划任务表</td>
    </tr>
    <tr>
      <td style='text-align:center;'>24</td>
      <td><a href='#sys_user'>sys_user</a></td>
      <td>用户表</td>
    </tr>
  </table>
  <a name='biz_account'></a>
  <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：biz_account</b>
  </div>
  <div>说明：模块API访问账号表</div>
  <div>数据列：</div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td>ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>Y</td>
      <td align='center'></td>
      <td align='center'>用户编号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td>MODULE_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>模块编号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td>USER_LOGON_NAME</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>用户登录账号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td>USER_DISPLAY_NAME</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>用户名称</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td>USER_PASSWORD</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>用户密码</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td>TELEPHONE</td>
      <td align='center'>varchar</td>
      <td align='center'>45</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>座机</td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td>MOBILEPHONE</td>
      <td align='center'>varchar</td>
      <td align='center'>45</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>手机</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td>EMAIL</td>
      <td align='center'>varchar</td>
      <td align='center'>45</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>邮箱</td>
    </tr>
    <tr>
      <td style='text-align:center;'>9</td>
      <td>IS_ENABLED</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'>1</td>
      <td align='center'>是否启用，0：禁用，1：启用</td>
    </tr>
    <tr>
      <td style='text-align:center;'>10</td>
      <td>REMARK</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>备注</td>
    </tr>
    <tr>
      <td style='text-align:center;'>11</td>
      <td>ISDEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标志位</td>
    </tr>
    <tr>
      <td style='text-align:center;'>12</td>
      <td>CREATOR</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>13</td>
      <td>CREATE_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>14</td>
      <td>MODIFIER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>15</td>
      <td>MODIFY_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>16</td>
      <td>VERSION_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
  </table>
  <a name='biz_module'></a>
  <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：biz_module</b></div>
  <div>说明：模块表</div>
  <div>数据列：</div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td>ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>Y</td>
      <td align='center'></td>
      <td align='center'>模块编号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td>MODULE_NAME</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>模块名称</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td>MODULE_SHORT_NAME</td>
      <td align='center'>varchar</td>
      <td align='center'>256</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>模块简称</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td>MODULE_SHORT_NAME_EN</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>模块英文简称</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td>MODULE_PROTOCOL</td>
      <td align='center'>varchar</td>
      <td align='center'>15</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>采用HTTP协议，HTTP或者HTTPS</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td>MODULE_ADDRESS</td>
      <td align='center'>varchar</td>
      <td align='center'>256</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>模块地址：ip或者域名</td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td>MODULE_PORT</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>模块端口</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td>MODULE_LOGO_ADDRESS</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>模块logo图片位置</td>
    </tr>
    <tr>
      <td style='text-align:center;'>9</td>
      <td>MODULE_SSO_ADDRESS</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>模块单点登录地址</td>
    </tr>
    <tr>
      <td style='text-align:center;'>10</td>
      <td>MODULE_TODO_ADDRESS</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>模块待办地址</td>
    </tr>
    <tr>
      <td style='text-align:center;'>11</td>
      <td>SERIAL_NUMBER</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>序号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>12</td>
      <td>REMARK</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>备注</td>
    </tr>
    <tr>
      <td style='text-align:center;'>13</td>
      <td>ISDEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标志位</td>
    </tr>
    <tr>
      <td style='text-align:center;'>14</td>
      <td>CREATOR</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>15</td>
      <td>CREATE_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>16</td>
      <td>MODIFIER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>17</td>
      <td>MODIFY_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>18</td>
      <td>VERSION_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
  </table>
  <a name='biz_user'></a>
  <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：biz_user</b></div>
  <div>说明：模块用户表</div>
  <div>数据列：</div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td>ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>Y</td>
      <td align='center'></td>
      <td align='center'>用户编号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td>USER_LOGON_NAME</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>用户登录账号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td>USER_DISPLAY_NAME</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>用户名称</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td>USER_PASSWORD</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>用户密码</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td>TELEPHONE</td>
      <td align='center'>varchar</td>
      <td align='center'>45</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>座机</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td>MOBILEPHONE</td>
      <td align='center'>varchar</td>
      <td align='center'>45</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>手机</td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td>EMAIL</td>
      <td align='center'>varchar</td>
      <td align='center'>45</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>邮箱</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td>IS_ENABLED</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'>1</td>
      <td align='center'>是否启用，0：禁用，1：启用</td>
    </tr>
    <tr>
      <td style='text-align:center;'>9</td>
      <td>REMARK</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>备注</td>
    </tr>
    <tr>
      <td style='text-align:center;'>10</td>
      <td>ISDEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标志位</td>
    </tr>
    <tr>
      <td style='text-align:center;'>11</td>
      <td>CREATOR</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>12</td>
      <td>CREATE_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>13</td>
      <td>MODIFIER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>14</td>
      <td>MODIFY_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>15</td>
      <td>VERSION_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
    <tr>
      <td style='text-align:center;'>16</td>
      <td>EXTEND1</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段1</td>
    </tr>
    <tr>
      <td style='text-align:center;'>17</td>
      <td>EXTEND2</td>
      <td align='center'>varchar</td>
      <td align='center'>64</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段2</td>
    </tr>
    <tr>
      <td style='text-align:center;'>18</td>
      <td>EXTEND3</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段3</td>
    </tr>
    <tr>
      <td style='text-align:center;'>19</td>
      <td>EXTEND4</td>
      <td align='center'>varchar</td>
      <td align='center'>256</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段4</td>
    </tr>
    <tr>
      <td style='text-align:center;'>20</td>
      <td>EXTEND5</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段5</td>
    </tr>
    <tr>
      <td style='text-align:center;'>21</td>
      <td>SEX</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'>0</td>
      <td align='center'>性别，男：0，女：1，第三性别：2</td>
    </tr>
    <tr>
      <td style='text-align:center;'>22</td>
      <td>SALT</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>盐</td>
    </tr>
  </table>
  <a name='biz_user_module'></a>
  <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：biz_user_module</b>
  </div>
  <div>说明：模块与用户关系表</div>
  <div>数据列：</div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td>ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>Y</td>
      <td align='center'></td>
      <td align='center'>主键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td>USER_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>用户编号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td>MODULE_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>模块编号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td>USER_MODULE_LOGON_NAME</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>用户所在模块登录账号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td>USER_MODULE_PASSWORD</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>用户所在模块登录密码</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td>REMARK</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>备注</td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td>ISDEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标志位</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td>CREATOR</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>9</td>
      <td>CREATE_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>10</td>
      <td>MODIFIER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>11</td>
      <td>MODIFY_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>12</td>
      <td>VERSION_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
  </table>
  <a name='sys_addressee'></a>
  <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：sys_addressee</b>
  </div>
  <div>说明：收件人表</div>
  <div>数据列：</div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td>ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>Y</td>
      <td align='center'></td>
      <td align='center'>主键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td>BUSINESS_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>业务编号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td>USER_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>用户编号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td>STATUS</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>状态，0：未读，1：已读</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td>REMARK</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>备注</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td>ISDEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标志位</td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td>CREATOR</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td>CREATE_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>9</td>
      <td>MODIFIER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>10</td>
      <td>MODIFY_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>11</td>
      <td>VERSION_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
  </table>
  <a name='sys_announcement'></a>
  <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：sys_announcement</b>
  </div>
  <div>说明：通知公告表</div>
  <div>数据列：</div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td>ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>Y</td>
      <td align='center'></td>
      <td align='center'>主键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td>TITLE</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标题</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td>CONTENT</td>
      <td align='center'>longtext</td>
      <td align='center'>2147483647</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>内容</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td>TYPE</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>类型，0：公告，1：通知</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td>STATUS</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>状态，0：开放，1：关闭</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td>REMARK</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>备注</td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td>ISDEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标志位</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td>CREATOR</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>9</td>
      <td>CREATE_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>10</td>
      <td>MODIFIER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>11</td>
      <td>MODIFY_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>12</td>
      <td>VERSION_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
  </table>
  <a name='sys_area'></a>
  <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：sys_area</b></div>
  <div>说明：行政区域表</div>
  <div>数据列：</div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td>ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>Y</td>
      <td align='center'></td>
      <td align='center'>主键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td>AREA_CODE</td>
      <td align='center'>varchar</td>
      <td align='center'>6</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>地区编码</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td>PARENT_AREA_CODE</td>
      <td align='center'>varchar</td>
      <td align='center'>6</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>父地区编码</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td>AREA_NAME</td>
      <td align='center'>varchar</td>
      <td align='center'>50</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>地区名称</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td>ZIP_CODE</td>
      <td align='center'>varchar</td>
      <td align='center'>50</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>邮政编码</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td>AREA_LEVEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>地区层级(1省份 2城市 3区县)</td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td>REMARK</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>备注</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td>ISDEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标志位</td>
    </tr>
    <tr>
      <td style='text-align:center;'>9</td>
      <td>CREATOR</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>10</td>
      <td>CREATE_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>11</td>
      <td>MODIFIER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>12</td>
      <td>MODIFY_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>13</td>
      <td>VERSION_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
  </table>
  <a name='sys_attachment'></a>
  <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：sys_attachment</b>
  </div>
  <div>说明：系统附件表</div>
  <div>数据列：</div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td>ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>Y</td>
      <td align='center'></td>
      <td align='center'>主键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td>FILE_NAME</td>
      <td align='center'>varchar</td>
      <td align='center'>1024</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>附件名称</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td>FILE_SIZE</td>
      <td align='center'>double</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>文件大小</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td>FILE_PATH</td>
      <td align='center'>varchar</td>
      <td align='center'>2048</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>存储路径</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td>BUSINESS_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>业务编号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td>REMARK</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>备注</td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td>ISDEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标志位</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td>CREATOR</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>9</td>
      <td>CREATE_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>10</td>
      <td>MODIFIER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>11</td>
      <td>MODIFY_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>12</td>
      <td>VERSION_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
  </table>
  <a name='sys_code_table'></a>
  <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：sys_code_table</b>
  </div>
  <div>说明：字典表</div>
  <div>数据列：</div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td>ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>Y</td>
      <td align='center'></td>
      <td align='center'>主键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td>CODE_NAME</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>名称</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td>CODE</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>编码</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td>VALUE</td>
      <td align='center'>varchar</td>
      <td align='center'>256</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>值</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td>PARENT_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>父键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td>REMARK</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>备注</td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td>SERIAL_NUMBER</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>序号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td>ISDEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标志位</td>
    </tr>
    <tr>
      <td style='text-align:center;'>9</td>
      <td>CREATOR</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>10</td>
      <td>CREATE_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>11</td>
      <td>MODIFIER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>12</td>
      <td>MODIFY_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>13</td>
      <td>VERSION_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
    <tr>
      <td style='text-align:center;'>14</td>
      <td>EXTEND1</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段1</td>
    </tr>
    <tr>
      <td style='text-align:center;'>15</td>
      <td>EXTEND2</td>
      <td align='center'>varchar</td>
      <td align='center'>64</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段2</td>
    </tr>
    <tr>
      <td style='text-align:center;'>16</td>
      <td>EXTEND3</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段3</td>
    </tr>
    <tr>
      <td style='text-align:center;'>17</td>
      <td>EXTEND4</td>
      <td align='center'>varchar</td>
      <td align='center'>256</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段4</td>
    </tr>
    <tr>
      <td style='text-align:center;'>18</td>
      <td>EXTEND5</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段5</td>
    </tr>
  </table>
  <a name='sys_import_config'></a>
  <div style='margin-top:30px;'><a href='#index'
                                   style='float:right; margin-top:6px;'>返回目录</a><b>表名：sys_import_config</b></div>
  <div>说明：导入配置主表</div>
  <div>数据列：</div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td>ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>Y</td>
      <td align='center'></td>
      <td align='center'>主键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td>CONFIG_NAME</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>配置名称</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td>START_ROW</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>起始行</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td>START_COLUMN</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>起始列</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td>WORKSHEET_INDEXES</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>工作簿索引列表</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td>SERIAL_NUMBER</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td>REMARK</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>备注</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td>ISDEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标志位</td>
    </tr>
    <tr>
      <td style='text-align:center;'>9</td>
      <td>CREATOR</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>10</td>
      <td>CREATE_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>11</td>
      <td>MODIFIER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>12</td>
      <td>MODIFY_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>13</td>
      <td>VERSION_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
  </table>
  <a name='sys_import_config_detail'></a>
  <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：sys_import_config_detail</b>
  </div>
  <div>说明：导入配置子表</div>
  <div>数据列：</div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td>ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>Y</td>
      <td align='center'></td>
      <td align='center'>主键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td>PARENT_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>父键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td>DATA_TYPE</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>数据类型，0：小数，1：整数，2：文本t，3：日期，4：时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td>CELLS</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>所在列</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td>REQUIRED</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>是否必填项，0：否，1：是</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td>MAX_VALUE</td>
      <td align='center'>double</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>最大值</td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td>MIN_VALUE</td>
      <td align='center'>double</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>最小值</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td>DECIMAL_LIMIT</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>小数位上限</td>
    </tr>
    <tr>
      <td style='text-align:center;'>9</td>
      <td>TEXT_ENUM</td>
      <td align='center'>varchar</td>
      <td align='center'>1024</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>枚举列表</td>
    </tr>
    <tr>
      <td style='text-align:center;'>10</td>
      <td>EXTEND1</td>
      <td align='center'>varchar</td>
      <td align='center'>64</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>扩展字段</td>
    </tr>
    <tr>
      <td style='text-align:center;'>11</td>
      <td>EXTEND2</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>扩展字段</td>
    </tr>
    <tr>
      <td style='text-align:center;'>12</td>
      <td>EXTEND3</td>
      <td align='center'>varchar</td>
      <td align='center'>256</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>扩展字段</td>
    </tr>
    <tr>
      <td style='text-align:center;'>13</td>
      <td>SERIAL_NUMBER</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>序号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>14</td>
      <td>REMARK</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>备注</td>
    </tr>
    <tr>
      <td style='text-align:center;'>15</td>
      <td>ISDEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标志位</td>
    </tr>
    <tr>
      <td style='text-align:center;'>16</td>
      <td>CREATOR</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>17</td>
      <td>CREATE_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>18</td>
      <td>MODIFIER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>19</td>
      <td>MODIFY_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>20</td>
      <td>VERSION_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
  </table>
  <a name='sys_language'></a>
  <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：sys_language</b>
  </div>
  <div>说明：系统语言</div>
  <div>数据列：</div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td>ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>Y</td>
      <td align='center'></td>
      <td align='center'>主键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td>LANGUAGE_NAME</td>
      <td align='center'>varchar</td>
      <td align='center'>45</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>名称</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td>ORDER_NUMBER</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>序号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td>REMARK</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>备注</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td>ISDEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标志位</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td>CREATOR</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td>CREATE_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td>MODIFIER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>9</td>
      <td>MODIFY_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>10</td>
      <td>VERSION_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
    <tr>
      <td style='text-align:center;'>11</td>
      <td>EXTEND1</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段1</td>
    </tr>
    <tr>
      <td style='text-align:center;'>12</td>
      <td>EXTEND2</td>
      <td align='center'>varchar</td>
      <td align='center'>64</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段2</td>
    </tr>
    <tr>
      <td style='text-align:center;'>13</td>
      <td>EXTEND3</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段3</td>
    </tr>
    <tr>
      <td style='text-align:center;'>14</td>
      <td>EXTEND4</td>
      <td align='center'>varchar</td>
      <td align='center'>256</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段4</td>
    </tr>
    <tr>
      <td style='text-align:center;'>15</td>
      <td>EXTEND5</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段5</td>
    </tr>
  </table>
  <a name='sys_log'></a>
  <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：sys_log</b></div>
  <div>说明：审计日志表</div>
  <div>数据列：</div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td>ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>Y</td>
      <td align='center'></td>
      <td align='center'>主键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td>USER_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>用户编号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td>USER_NAME</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>用户姓名</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td>ORG_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>机构编号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td>ORG_NAME</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>机构名称</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td>SYSTEM</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>使用系统</td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td>BROWSER</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>浏览器</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td>IP</td>
      <td align='center'>varchar</td>
      <td align='center'>45</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>IP地址</td>
    </tr>
    <tr>
      <td style='text-align:center;'>9</td>
      <td>OPERATION_TYPE</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>
        操作类型，0：查询列表，1：查询记录，2：新增，3：编辑，4：逻辑删除，5：物理删除，6：上传，7：下载，8：导入，9：导出，10：菜单授权，11：用户授权，12：打印，13：登录，14：登出，15：强制登出，16：更新密码，17：添加计划任务，18：暂停计划任务，19：启动计划任务
      </td>
    </tr>
    <tr>
      <td style='text-align:center;'>10</td>
      <td>REQUEST_METHOD</td>
      <td align='center'>varchar</td>
      <td align='center'>20</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>请求方法</td>
    </tr>
    <tr>
      <td style='text-align:center;'>11</td>
      <td>REQUEST_URL</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>请求路径</td>
    </tr>
    <tr>
      <td style='text-align:center;'>12</td>
      <td>PARAMS</td>
      <td align='center'>varchar</td>
      <td align='center'>1024</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>请求参数</td>
    </tr>
    <tr>
      <td style='text-align:center;'>13</td>
      <td>RESULT</td>
      <td align='center'>longblob</td>
      <td align='center'>2147483647</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>返回结果</td>
    </tr>
    <tr>
      <td style='text-align:center;'>14</td>
      <td>OLD_VALUE</td>
      <td align='center'>longblob</td>
      <td align='center'>2147483647</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>旧值</td>
    </tr>
    <tr>
      <td style='text-align:center;'>15</td>
      <td>NEW_VALUE</td>
      <td align='center'>longblob</td>
      <td align='center'>2147483647</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>新值</td>
    </tr>
    <tr>
      <td style='text-align:center;'>16</td>
      <td>REMARK</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>备注</td>
    </tr>
    <tr>
      <td style='text-align:center;'>17</td>
      <td>ISDEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标志位</td>
    </tr>
    <tr>
      <td style='text-align:center;'>18</td>
      <td>CREATOR</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>19</td>
      <td>CREATE_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>20</td>
      <td>MODIFIER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>21</td>
      <td>MODIFY_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>22</td>
      <td>VERSION_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
  </table>
  <a name='sys_menu'></a>
  <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：sys_menu</b></div>
  <div>说明：菜单表</div>
  <div>数据列：</div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td>ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>Y</td>
      <td align='center'></td>
      <td align='center'>主键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td>PATH</td>
      <td align='center'>varchar</td>
      <td align='center'>256</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>根路径</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td>MENU_NAME</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>角色名称</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td>MENU_URL</td>
      <td align='center'>varchar</td>
      <td align='center'>256</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>菜单路径</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td>PARENT_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>父键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td>SERIAL_NUMBER</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>序号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td>MENU_TYPE</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>菜单类型，0：菜单，1：按钮，视图：2</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td>ICON</td>
      <td align='center'>varchar</td>
      <td align='center'>256</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>图标</td>
    </tr>
    <tr>
      <td style='text-align:center;'>9</td>
      <td>CODE</td>
      <td align='center'>varchar</td>
      <td align='center'>125</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>编码</td>
    </tr>
    <tr>
      <td style='text-align:center;'>10</td>
      <td>REMARK</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>备注</td>
    </tr>
    <tr>
      <td style='text-align:center;'>11</td>
      <td>ISDEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标志位</td>
    </tr>
    <tr>
      <td style='text-align:center;'>12</td>
      <td>CREATOR</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>13</td>
      <td>CREATE_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>14</td>
      <td>MODIFIER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>15</td>
      <td>MODIFY_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>16</td>
      <td>VERSION_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
    <tr>
      <td style='text-align:center;'>17</td>
      <td>EXTEND1</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段1</td>
    </tr>
    <tr>
      <td style='text-align:center;'>18</td>
      <td>EXTEND2</td>
      <td align='center'>varchar</td>
      <td align='center'>64</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段2</td>
    </tr>
    <tr>
      <td style='text-align:center;'>19</td>
      <td>EXTEND3</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段3</td>
    </tr>
    <tr>
      <td style='text-align:center;'>20</td>
      <td>EXTEND4</td>
      <td align='center'>varchar</td>
      <td align='center'>256</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段4</td>
    </tr>
    <tr>
      <td style='text-align:center;'>21</td>
      <td>EXTEND5</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段5</td>
    </tr>
  </table>
  <a name='sys_menu_language'></a>
  <div style='margin-top:30px;'><a href='#index'
                                   style='float:right; margin-top:6px;'>返回目录</a><b>表名：sys_menu_language</b></div>
  <div>说明：菜单多语表</div>
  <div>数据列：</div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td>ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>Y</td>
      <td align='center'></td>
      <td align='center'>主键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td>MENU_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>菜单编号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td>LANGUAGE_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>语言编号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td>MENU_NAME</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>菜单名称</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td>REMARK</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>备注</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td>ISDEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标志位</td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td>CREATOR</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td>CREATE_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>9</td>
      <td>MODIFIER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>10</td>
      <td>MODIFY_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>11</td>
      <td>VERSION_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
  </table>
  <a name='sys_org_user'></a>
  <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：sys_org_user</b>
  </div>
  <div>说明：机构用户关系表</div>
  <div>数据列：</div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td>ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>Y</td>
      <td align='center'></td>
      <td align='center'>主键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td>ORG_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>机构编号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td>USER_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>用户编号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td>REMARK</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>备注</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td>ISDEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标志位</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td>CREATOR</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td>CREATE_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td>MODIFIER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>9</td>
      <td>MODIFY_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>10</td>
      <td>VERSION_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
  </table>
  <a name='sys_organization'></a>
  <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：sys_organization</b>
  </div>
  <div>说明：机构表</div>
  <div>数据列：</div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td>ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>Y</td>
      <td align='center'></td>
      <td align='center'>主键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td>ORG_NAME</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>机构名称</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td>PARENT_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>父键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td>LEADER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>主管人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td>SERIAL_NUMBER</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>序号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td>REMARK</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>备注</td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td>ISDEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标志位</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td>CREATOR</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>9</td>
      <td>CREATE_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>10</td>
      <td>MODIFIER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>11</td>
      <td>MODIFY_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>12</td>
      <td>VERSION_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
    <tr>
      <td style='text-align:center;'>13</td>
      <td>EXTEND1</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段1</td>
    </tr>
    <tr>
      <td style='text-align:center;'>14</td>
      <td>EXTEND2</td>
      <td align='center'>varchar</td>
      <td align='center'>64</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段2</td>
    </tr>
    <tr>
      <td style='text-align:center;'>15</td>
      <td>EXTEND3</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段3</td>
    </tr>
    <tr>
      <td style='text-align:center;'>16</td>
      <td>EXTEND4</td>
      <td align='center'>varchar</td>
      <td align='center'>256</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段4</td>
    </tr>
    <tr>
      <td style='text-align:center;'>17</td>
      <td>EXTEND5</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段5</td>
    </tr>
  </table>
  <a name='sys_record'></a>
  <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：sys_record</b></div>
  <div>说明：系统记录表</div>
  <div>数据列：</div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td>ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>Y</td>
      <td align='center'></td>
      <td align='center'>主键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td>REMARK</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>备注</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td>ISDEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标志位</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td>CREATOR</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td>CREATE_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td>MODIFIER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td>MODIFY_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td>VERSION_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
  </table>
  <a name='sys_role'></a>
  <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：sys_role</b></div>
  <div>说明：角色表</div>
  <div>数据列：</div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td>ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>Y</td>
      <td align='center'></td>
      <td align='center'>主键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td>ROLE_NAME</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>角色名称</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td>SERIAL_NUMBER</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>序号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td>REMARK</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>备注</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td>ISDEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标志位</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td>CREATOR</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td>CREATE_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td>MODIFIER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>9</td>
      <td>MODIFY_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>10</td>
      <td>VERSION_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
    <tr>
      <td style='text-align:center;'>11</td>
      <td>EXTEND1</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段1</td>
    </tr>
    <tr>
      <td style='text-align:center;'>12</td>
      <td>EXTEND2</td>
      <td align='center'>varchar</td>
      <td align='center'>64</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段2</td>
    </tr>
    <tr>
      <td style='text-align:center;'>13</td>
      <td>EXTEND3</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段3</td>
    </tr>
    <tr>
      <td style='text-align:center;'>14</td>
      <td>EXTEND4</td>
      <td align='center'>varchar</td>
      <td align='center'>256</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段4</td>
    </tr>
    <tr>
      <td style='text-align:center;'>15</td>
      <td>EXTEND5</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段5</td>
    </tr>
  </table>
  <a name='sys_role_menu'></a>
  <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：sys_role_menu</b>
  </div>
  <div>说明：角色菜单关系表</div>
  <div>数据列：</div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td>ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>Y</td>
      <td align='center'></td>
      <td align='center'>主键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td>ROLE_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>角色编号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td>MENU_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>菜单编号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td>REMARK</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>备注</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td>ISDEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标志位</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td>CREATOR</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td>CREATE_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td>MODIFIER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>9</td>
      <td>MODIFY_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>10</td>
      <td>VERSION_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
  </table>
  <a name='sys_role_org'></a>
  <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：sys_role_org</b>
  </div>
  <div>说明：角色机构关系表</div>
  <div>数据列：</div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td>ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>Y</td>
      <td align='center'></td>
      <td align='center'>主键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td>ROLE_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>角色编号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td>ORG_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>机构编号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td>OWNER_TYPE</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>类型：0，自有；1继承</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td>REMARK</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>备注</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td>ISDEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标志位</td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td>CREATOR</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td>CREATE_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>9</td>
      <td>MODIFIER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>10</td>
      <td>MODIFY_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>11</td>
      <td>VERSION_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
  </table>
  <a name='sys_role_user'></a>
  <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：sys_role_user</b>
  </div>
  <div>说明：角色用户关系表</div>
  <div>数据列：</div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td>ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>Y</td>
      <td align='center'></td>
      <td align='center'>主键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td>ROLE_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>角色编号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td>USER_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>用户编号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td>REMARK</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>备注</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td>ISDEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标志位</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td>CREATOR</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td>CREATE_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td>MODIFIER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>9</td>
      <td>MODIFY_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>10</td>
      <td>VERSION_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
  </table>
  <a name='sys_schedule_job'></a>
  <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：sys_schedule_job</b>
  </div>
  <div>说明：计划任务表</div>
  <div>数据列：</div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td>ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>Y</td>
      <td align='center'></td>
      <td align='center'>主键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td>JOB_NAME</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>任务名称</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td>JOB_DESCRIPTION</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>任务描述</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td>NAMESPACE</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>命名空间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td>JOB_IMPLEMENT</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>实现类</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td>CRON_EXPRESSION</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>Cron表达式</td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td>START_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>19</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>开始时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td>END_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>19</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>结束时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>9</td>
      <td>JOB_STATUS</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>任务状态，0：已启用，1：运行中，2：执行中，3：执行完成，4：任务计划中，5：已停止</td>
    </tr>
    <tr>
      <td style='text-align:center;'>10</td>
      <td>GROUP_ID</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>集群编号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>11</td>
      <td>SERIAL_NUMBER</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>序号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>12</td>
      <td>REMARK</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>备注</td>
    </tr>
    <tr>
      <td style='text-align:center;'>13</td>
      <td>ISDEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标志位</td>
    </tr>
    <tr>
      <td style='text-align:center;'>14</td>
      <td>CREATOR</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>15</td>
      <td>CREATE_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>16</td>
      <td>MODIFIER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>17</td>
      <td>MODIFY_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>18</td>
      <td>VERSION_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
  </table>
  <a name='sys_user'></a>
  <div style='margin-top:30px;'><a href='#index' style='float:right; margin-top:6px;'>返回目录</a><b>表名：sys_user</b></div>
  <div>说明：用户表</div>
  <div>数据列：</div>
  <table cellspacing='1'>
    <thead>
    <tr>
      <td style='width:40px; '>序号</td>
      <td>名称</td>
      <td>数据类型</td>
      <td>长度</td>
      <td>小数位</td>
      <td>允许空值</td>
      <td>主键</td>
      <td>默认值</td>
      <td>说明</td>
    </tr>
    </thead>
    <tr>
      <td style='text-align:center;'>1</td>
      <td>ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>Y</td>
      <td align='center'></td>
      <td align='center'>主键</td>
    </tr>
    <tr>
      <td style='text-align:center;'>2</td>
      <td>LOGON_NAME</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>登录名称</td>
    </tr>
    <tr>
      <td style='text-align:center;'>3</td>
      <td>DISPLAY_NAME</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>用户姓名</td>
    </tr>
    <tr>
      <td style='text-align:center;'>4</td>
      <td>PASSWORD</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>登陆密码</td>
    </tr>
    <tr>
      <td style='text-align:center;'>5</td>
      <td>TELEPHONE</td>
      <td align='center'>varchar</td>
      <td align='center'>45</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>座机</td>
    </tr>
    <tr>
      <td style='text-align:center;'>6</td>
      <td>MOBILEPHONE</td>
      <td align='center'>varchar</td>
      <td align='center'>45</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>手机</td>
    </tr>
    <tr>
      <td style='text-align:center;'>7</td>
      <td>EMAIL</td>
      <td align='center'>varchar</td>
      <td align='center'>45</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>邮箱</td>
    </tr>
    <tr>
      <td style='text-align:center;'>8</td>
      <td>REMARK</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>备注</td>
    </tr>
    <tr>
      <td style='text-align:center;'>9</td>
      <td>IS_SUPPER_ADMIN</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>是否是超级管理员</td>
    </tr>
    <tr>
      <td style='text-align:center;'>10</td>
      <td>SERIAL_NUMBER</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>序号</td>
    </tr>
    <tr>
      <td style='text-align:center;'>11</td>
      <td>IS_ENABLED</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'>1</td>
      <td align='center'>是否启用，0：禁用，1：启用</td>
    </tr>
    <tr>
      <td style='text-align:center;'>12</td>
      <td>ISDEL</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>标志位</td>
    </tr>
    <tr>
      <td style='text-align:center;'>13</td>
      <td>CREATOR</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>14</td>
      <td>CREATE_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>创建时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>15</td>
      <td>MODIFIER</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改人</td>
    </tr>
    <tr>
      <td style='text-align:center;'>16</td>
      <td>MODIFY_TIME</td>
      <td align='center'>datetime</td>
      <td align='center'>23</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>修改时间</td>
    </tr>
    <tr>
      <td style='text-align:center;'>17</td>
      <td>VERSION_ID</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'></td>
    </tr>
    <tr>
      <td style='text-align:center;'>18</td>
      <td>EXTEND1</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段1</td>
    </tr>
    <tr>
      <td style='text-align:center;'>19</td>
      <td>EXTEND2</td>
      <td align='center'>varchar</td>
      <td align='center'>64</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段2</td>
    </tr>
    <tr>
      <td style='text-align:center;'>20</td>
      <td>EXTEND3</td>
      <td align='center'>varchar</td>
      <td align='center'>128</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段3</td>
    </tr>
    <tr>
      <td style='text-align:center;'>21</td>
      <td>EXTEND4</td>
      <td align='center'>varchar</td>
      <td align='center'>256</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段4</td>
    </tr>
    <tr>
      <td style='text-align:center;'>22</td>
      <td>EXTEND5</td>
      <td align='center'>varchar</td>
      <td align='center'>512</td>
      <td align='center'>0</td>
      <td align='center'>Y</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>预留字段5</td>
    </tr>
    <tr>
      <td style='text-align:center;'>23</td>
      <td>SEX</td>
      <td align='center'>int</td>
      <td align='center'>10</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'>0</td>
      <td align='center'>性别，男：0，女：1，第三性别：2</td>
    </tr>
    <tr>
      <td style='text-align:center;'>24</td>
      <td>SALT</td>
      <td align='center'>varchar</td>
      <td align='center'>36</td>
      <td align='center'>0</td>
      <td align='center'>N</td>
      <td align='center'>N</td>
      <td align='center'></td>
      <td align='center'>盐</td>
    </tr>
  </table>
</div>
<footer></footer>
</body>
</html>
